/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : moose

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 26/01/2021 19:53:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for clientdetails
-- ----------------------------
DROP TABLE IF EXISTS `clientdetails`;
CREATE TABLE `clientdetails` (
  `appId` varchar(128) NOT NULL,
  `resourceIds` varchar(256) DEFAULT NULL,
  `appSecret` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `grantTypes` varchar(256) DEFAULT NULL,
  `redirectUrl` varchar(256) DEFAULT NULL,
  `authorities` varchar(256) DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additionalInformation` varchar(4096) DEFAULT NULL,
  `autoApproveScopes` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`appId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oauth_access_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE `oauth_access_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication_id` varchar(128) NOT NULL,
  `user_name` varchar(256) DEFAULT NULL,
  `client_id` varchar(256) DEFAULT NULL,
  `authentication` blob,
  `refresh_token` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oauth_approvals
-- ----------------------------
DROP TABLE IF EXISTS `oauth_approvals`;
CREATE TABLE `oauth_approvals` (
  `userId` varchar(256) DEFAULT NULL,
  `clientId` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `expiresAt` timestamp NULL DEFAULT NULL,
  `lastModifiedAt` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(128) NOT NULL,
  `resource_ids` varchar(256) DEFAULT NULL,
  `client_secret` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `authorized_grant_types` varchar(256) DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) DEFAULT NULL,
  `authorities` varchar(256) DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additional_information` varchar(4096) DEFAULT NULL,
  `autoapprove` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` VALUES ('client', 'app-resources', '$2a$10$zImwN.AOfOTU6m9xewoDZOqKHL3YThE4naYi5E1g13ZW2sjF.di8S', 'app', 'sms_code,password,refresh_token', NULL, NULL, 86400, 2592000, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE `oauth_client_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication_id` varchar(128) NOT NULL,
  `user_name` varchar(256) DEFAULT NULL,
  `client_id` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code` (
  `code` varchar(256) DEFAULT NULL,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oauth_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token` (
  `token_id` varchar(256) DEFAULT NULL,
  `token` blob,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_account
-- ----------------------------
DROP TABLE IF EXISTS `t_account`;
CREATE TABLE `t_account` (
  `account_id` bigint(20) NOT NULL,
  `account_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户名',
  `status` varchar(1) COLLATE utf8_bin DEFAULT '1' COMMENT '帐号启用状态:0->禁用；1->启用',
  `phone` varchar(11) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '手机号',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  UNIQUE KEY `uniq_account_id` (`account_id`),
  UNIQUE KEY `uniq_account_name` (`account_name`) USING BTREE,
  KEY `idx_account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='账号表';

-- ----------------------------
-- Records of t_account
-- ----------------------------
BEGIN;
INSERT INTO `t_account` VALUES (775113182741004288, '王昭君', '1', '13611083015', '2020-11-08 21:43:03', '2021-01-23 23:23:45');
INSERT INTO `t_account` VALUES (775113182741004290, '江景', '1', '15989898989', '2020-11-08 22:43:03', '2021-01-23 22:23:45');
INSERT INTO `t_account` VALUES (801901011387289600, '陆游', '1', '15813488120', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011458592800, '王世贞', '1', '15898130334', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011517313000, '刘克庄', '1', '15581082859', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011563450400, '杨万里', '1', '18961741677', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011609587700, '苏轼', '1', '18798473261', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011668308000, '白居易', '1', '18836246738', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011706056700, '胡应麟', '1', '13228841967', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011760582700, '赵蕃', '1', '18878852586', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011798331400, '黄庭坚', '1', '13825546127', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011840274400, '范成大', '1', '13454134095', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011878023200, '梅尧臣', '1', '18679909527', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011915771900, '韩淲', '1', '15540312077', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011953520600, '王安石', '1', '18461719893', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901011991269400, '苏辙', '1', '18658115281', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012045795300, '曹勋', '1', '18478643423', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012083544000, '方回', '1', '18751407687', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012133875700, '王十朋', '1', '15241380417', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012175818800, '周紫芝', '1', '15477339818', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012209373200, '李梦阳', '1', '13688416231', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012251316200, '杨士奇', '1', '18532333848', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012301647900, '陈著', '1', '18997335769', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012385534000, '陈献章', '1', '15637614956', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012444254200, '张耒', '1', '18405122833', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012482003000, '顾璘', '1', '15422244137', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012523946000, '陈恭尹', '1', '18247373284', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012557500400, '朱熹', '1', '15422475615', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012599443500, '胡奎', '1', '18422217748', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012632997900, '郭之奇', '1', '18477082327', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012670746600, '卢龙云', '1', '18124632624', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012704301000, '杜甫', '1', '18188954087', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012737855500, '丘逢甲', '1', '18508101545', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012771409900, '方岳', '1', '15773664531', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012821741600, '欧阳修', '1', '13167726745', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012863684600, '刘敞', '1', '15654263748', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012897239000, '释居简', '1', '18341263076', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012930793500, '邵宝', '1', '18144391441', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901012968542200, '陈维崧', '1', '18618500019', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013006291000, '徐熥', '1', '13468922780', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013048234000, '黎民表', '1', '15662326222', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013090177000, '袁宏道', '1', '18597912218', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013127925800, '邵雍', '1', '15952652416', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013157285900, '何景明', '1', '15845583161', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013199228900, '顾清', '1', '15672793146', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013245366300, '区大相', '1', '15487812276', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013287309300, '王之道', '1', '13734255173', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013320863700, '刘基', '1', '15477712314', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013383778300, '湛若水', '1', '18332797996', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013425721300, '皇甫汸', '1', '15917305268', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013459275800, '王夫之', '1', '13333883861', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013505413100, '李白', '1', '15428431857', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013547356200, '李东阳', '1', '15104371904', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013585104900, '徐渭', '1', '15725101476', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013618659300, '杨慎', '1', '18786382302', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013656408000, '陈造', '1', '13749525214', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013689962500, '边贡', '1', '13859702057', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013719322600, '宋祁', '1', '15533092166', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013752877000, '郭祥正', '1', '15797559133', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013794820100, '释函可', '1', '13774241117', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013836763100, '郑孝胥', '1', '18434665331', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013870317600, '司马光', '1', '18474441288', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013908066300, '李攀龙', '1', '15226573640', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013941620700, '吴与弼', '1', '15450045410', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901013991952400, '吕本中', '1', '18126955318', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014033895400, '薛瑄', '1', '18714240165', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014067449900, '吴芾', '1', '15420627351', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014101004300, '王恭', '1', '15780153427', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014134558700, '释今无', '1', '18610112683', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014172307500, '李孙宸', '1', '18585168471', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014205861900, '刘攽', '1', '18877432548', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014235222000, '黄衷', '1', '15761533238', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014268776400, '戴亨', '1', '13406240527', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014306525200, '辛弃疾', '1', '13952738322', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014340079600, '晁补之', '1', '18647556841', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014382022700, '洪咨夔', '1', '15421287555', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014419771400, '谢榛', '1', '13158681776', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014453325800, '韦骧', '1', '18901582381', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014486880300, '韩维', '1', '13204425728', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014520434700, '李曾伯', '1', '18215312684', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014553989100, '彭汝砺', '1', '18222866724', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014587543600, '释文珦', '1', '18862469557', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014621098000, '张宁', '1', '18423954303', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014650458100, '李之仪', '1', '15637872432', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014684012500, '齐己', '1', '18279477874', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014713372700, '魏了翁', '1', '15516078516', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014746927100, '郑善夫', '1', '18741368574', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014788870100, '庄昶', '1', '18375847878', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014822424600, '沈周', '1', '18709768531', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014855979000, '张弼', '1', '15735625393', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014885339100, '刘禹锡', '1', '15315362386', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014918893600, '全祖望', '1', '15858836673', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014948253700, '张昱', '1', '13882687372', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901014977613800, '白玉蟾', '1', '18740376030', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015011168300, '陈子升', '1', '18848413578', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015044722700, '黄省曾', '1', '18213480461', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015078277100, '洪适', '1', '18726838033', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015111831600, '张元凯', '1', '18553638651', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015145386000, '杨维桢', '1', '13433611554', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015178940400, '秦观', '1', '13339871535', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015212494800, '高启', '1', '15434294486', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
INSERT INTO `t_account` VALUES (801901015241855000, '陈宝琛', '1', '15341873710', '2021-01-21 19:49:33', '2021-01-21 19:49:33');
COMMIT;

-- ----------------------------
-- Table structure for t_attachment_record
-- ----------------------------
DROP TABLE IF EXISTS `t_attachment_record`;
CREATE TABLE `t_attachment_record` (
  `attach_id` bigint(20) NOT NULL COMMENT '附件文件Id',
  `user_id` bigint(20) NOT NULL COMMENT '用户Id',
  `e_tag` char(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'oss 上传标记',
  `file_url` varchar(120) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'oss 文件路径',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`attach_id`),
  KEY `idx_attach_id` (`attach_id`),
  KEY `idx_e_tag` (`e_tag`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='文件记录表';

-- ----------------------------
-- Table structure for t_dynamic_record
-- ----------------------------
DROP TABLE IF EXISTS `t_dynamic_record`;
CREATE TABLE `t_dynamic_record` (
  `dr_id` bigint(20) NOT NULL COMMENT '动态记录Id',
  `user_id` bigint(20) NOT NULL COMMENT '用户Id',
  `title` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '动态标题',
  `content` varchar(500) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '动态描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`dr_id`),
  KEY `idx_dr_id` (`dr_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='发布动态记录表';

-- ----------------------------
-- Records of t_dynamic_record
-- ----------------------------
BEGIN;
INSERT INTO `t_dynamic_record` VALUES (777268848452964352, 775113183131074560, '常见的社会潜规则有哪些？', '1、越是能力强,靠谱的人,领导越会把又累又麻烦的事交给他,因为这样的人才能做好,', '2020-11-14 20:28:54', '2020-11-14 20:28:54');
INSERT INTO `t_dynamic_record` VALUES (777269863684247552, 775113183131074560, 'CorsConfiguration', '@Configuration\npublic class CorsConfiguration implements WebMvcConfigurer {\n  @Override public void addCorsMappings(CorsRegistry registry) {\n    registry.addMapping(\"/**\")\n        .allowedOrigins(\"*\")\n        .allowedHeaders(\"*\")\n        .allowedMethods(\"GET\", \"HEAD\", \"POST\", \"PUT\", \"DELETE\", \"OPTIONS\")\n        .allowCredentials(true)\n        .maxAge(3600);\n  }\n}', '2020-11-14 20:32:56', '2020-11-14 20:32:56');
COMMIT;

-- ----------------------------
-- Table structure for t_dynamic_record_attachment_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_dynamic_record_attachment_relation`;
CREATE TABLE `t_dynamic_record_attachment_relation` (
  `dra_id` bigint(20) NOT NULL COMMENT '关联表Id',
  `attach_id` bigint(20) NOT NULL COMMENT '附件文件Id',
  `dr_id` bigint(20) NOT NULL COMMENT '记录Id',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`dra_id`),
  KEY `idx_attach_id` (`attach_id`),
  KEY `idx_dr_id` (`dr_id`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='动态记录附件关联表';

-- ----------------------------
-- Table structure for t_password
-- ----------------------------
DROP TABLE IF EXISTS `t_password`;
CREATE TABLE `t_password` (
  `password_id` bigint(20) NOT NULL COMMENT '密码ID',
  `account_id` bigint(20) NOT NULL COMMENT '账号ID',
  `password` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '密码',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  UNIQUE KEY `uniq_password_id` (`password_id`),
  UNIQUE KEY `uniq_account_id` (`account_id`),
  KEY `t_account_password_ibfk_1` (`account_id`),
  KEY `idx_password_id` (`password_id`),
  CONSTRAINT `t_account_password_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `t_account` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='密码表';

-- ----------------------------
-- Records of t_password
-- ----------------------------
BEGIN;
INSERT INTO `t_password` VALUES (775113182741004210, 775113182741004290, '$2a$10$ASwQ9tpDD4u1TPX0DdYPSe4loW.mnOOBghHLFnIOkmZ1a4EIDdho.', '2020-11-08 22:43:03', '2020-11-08 22:43:03');
INSERT INTO `t_password` VALUES (775113182745198592, 775113182741004288, '$2a$10$ASwQ9tpDD4u1TPX0DdYPSe4loW.mnOOBghHLFnIOkmZ1a4EIDdho.', '2020-11-08 21:43:03', '2020-11-08 21:43:03');
INSERT INTO `t_password` VALUES (801901011412455400, 801901011387289600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011479564300, 801901011458592800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011534090200, 801901011517313000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011580227600, 801901011563450400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011626364900, 801901011609587700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011680890900, 801901011668308000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011727028200, 801901011706056700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011773165600, 801901011760582700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011810914300, 801901011798331400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011852857300, 801901011840274400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011890606100, 801901011878023200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011928354800, 801901011915771900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901011966103600, 801901011953520600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012012240900, 801901011991269400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012054184000, 801901012045795300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012096127000, 801901012083544000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012146458600, 801901012133875700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012188401700, 801901012175818800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012221956100, 801901012209373200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012268093400, 801901012251316200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012322619400, 801901012301647900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012419088400, 801901012385534000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012456837100, 801901012444254200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012494585900, 801901012482003000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012536528900, 801901012523946000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012570083300, 801901012557500400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012607832000, 801901012599443500, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012645580800, 801901012632997900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012683329500, 801901012670746600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012716884000, 801901012704301000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012750438400, 801901012737855500, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012783992800, 801901012771409900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012838518800, 801901012821741600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012872073200, 801901012863684600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012905627600, 801901012897239000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012939182100, 801901012930793500, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901012981125100, 801901012968542200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013018873900, 801901013006291000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013060816900, 801901013048234000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013102760000, 801901013090177000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013136314400, 801901013127925800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013169868800, 801901013157285900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013216006100, 801901013199228900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013266337800, 801901013245366300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013299892200, 801901013287309300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013333446700, 801901013320863700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013396361200, 801901013383778300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013434110000, 801901013425721300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013467664400, 801901013459275800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013522190300, 801901013505413100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013559939100, 801901013547356200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013593493500, 801901013585104900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013631242200, 801901013618659300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013668991000, 801901013656408000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013698351100, 801901013689962500, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013731905500, 801901013719322600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013765460000, 801901013752877000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013815791600, 801901013794820100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013845151700, 801901013836763100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013878706200, 801901013870317600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013916454900, 801901013908066300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901013954203600, 801901013941620700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014008729600, 801901013991952400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014042284000, 801901014033895400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014080032800, 801901014067449900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014113587200, 801901014101004300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014151336000, 801901014134558700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014184890400, 801901014172307500, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014218444800, 801901014205861900, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014247804900, 801901014235222000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014277165000, 801901014268776400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014314913800, 801901014306525200, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014348468200, 801901014340079600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014394605600, 801901014382022700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014428160000, 801901014419771400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014465908700, 801901014453325800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014499463200, 801901014486880300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014528823300, 801901014520434700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014566572000, 801901014553989100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014595932200, 801901014587543600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014629486600, 801901014621098000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014663041000, 801901014650458100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014692401200, 801901014684012500, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014725955600, 801901014713372700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014759510000, 801901014746927100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014797258800, 801901014788870100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014830813200, 801901014822424600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014864367600, 801901014855979000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014897922000, 801901014885339100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014927282200, 801901014918893600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014960836600, 801901014948253700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901014990196700, 801901014977613800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015023751200, 801901015011168300, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015053111300, 801901015044722700, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015090860000, 801901015078277100, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015120220200, 801901015111831600, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015153774600, 801901015145386000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015191523300, 801901015178940400, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015220883500, 801901015212494800, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
INSERT INTO `t_password` VALUES (801901015254437900, 801901015241855000, '$2a$10$Ll17vDGG3DoABuy9L026KeqjAasYknMXR3cHmxiTyfDl9dS8RtGbi', '2021-01-21 19:49:42', '2021-01-21 19:49:42');
COMMIT;

-- ----------------------------
-- Table structure for t_sms_verify
-- ----------------------------
DROP TABLE IF EXISTS `t_sms_verify`;
CREATE TABLE `t_sms_verify` (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '短信验证码ID',
  `phone` char(11) COLLATE utf8_bin NOT NULL COMMENT '手机号码',
  `type` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '短信类型',
  `code` char(6) COLLATE utf8_bin NOT NULL COMMENT '验证码',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_phone` (`phone`),
  KEY `idx_type` (`type`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='短信验证码表';

-- ----------------------------
-- Records of t_sms_verify
-- ----------------------------
BEGIN;
INSERT INTO `t_sms_verify` VALUES (1, '13511083015', 'sms_login', '098477', '2020-11-14 20:35:34', '2020-11-14 20:47:50');
INSERT INTO `t_sms_verify` VALUES (2, '13511083015', 'sms_login', '214395', '2020-11-14 20:48:06', '2020-11-14 20:48:06');
INSERT INTO `t_sms_verify` VALUES (3, '13611083015', 'sms_login', '110245', '2020-11-14 20:48:33', '2020-11-14 20:48:33');
COMMIT;

-- ----------------------------
-- Table structure for t_user_growth
-- ----------------------------
DROP TABLE IF EXISTS `t_user_growth`;
CREATE TABLE `t_user_growth` (
  `ug_id` bigint(20) NOT NULL COMMENT '成才值 Id',
  `user_id` bigint(20) NOT NULL COMMENT '用户 Id',
  `growth` int(20) NOT NULL COMMENT '成才值',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  KEY `idx_g_id` (`ug_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户成才值表';

-- ----------------------------
-- Table structure for t_user_info
-- ----------------------------
DROP TABLE IF EXISTS `t_user_info`;
CREATE TABLE `t_user_info` (
  `user_id` bigint(20) NOT NULL COMMENT '用户Id',
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户名',
  `account_id` bigint(20) NOT NULL,
  `account_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户名',
  `phone` varchar(11) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '手机号',
  `gender` char(1) COLLATE utf8_bin NOT NULL COMMENT '性别 male 1； female 2；un_known or hide 0',
  `avatar` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '头像',
  `email` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  `job` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '职位',
  `address` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '地址',
  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `uniq_phone` (`phone`),
  UNIQUE KEY `uniq_user_id` (`user_id`),
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_account_id` (`account_id`),
  UNIQUE KEY `uniq_account_name` (`account_name`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户信息表';

-- ----------------------------
-- Records of t_user_info
-- ----------------------------
BEGIN;
INSERT INTO `t_user_info` VALUES (775113183131074560, '王昭君', 775113182741004288, '王昭君', '13611083015', '0', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-10-20/8fdb6eae-3bb2-4eb1-9b37-e2c38ff8dea4.png', 'wangzhaojun@gmail.com', NULL, NULL, NULL, '2020-11-08 21:43:03', '2021-01-23 23:24:20');
INSERT INTO `t_user_info` VALUES (775113183131074580, '江景', 775113182741004290, '江景', '15989898989', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-10-20/8fdb6eae-3bb2-4eb1-9b37-e2c38ff8dea4.png', 'shizidada@gmail.com', NULL, NULL, NULL, '2020-11-08 22:43:03', '2021-01-23 22:24:20');
INSERT INTO `t_user_info` VALUES (801901010888167400, '陆游', 801901011387289600, '陆游', '15813488120', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'luyou@gmail.com', '', '', '陆游（1125—1210），字务观，号放翁。汉族，越州山阴（今浙江绍兴）人，南宋著名诗人。少时受家庭爱国思想熏陶，高宗时应礼部试，为秦桧所黜。孝宗时赐进士出身。中年入蜀，投身军旅生活，官至宝章阁待制。晚年退居家乡。创作诗歌今存九千多首，内容极为丰富。著有《剑南诗稿》、《渭南文集》、《南唐书》、《老学庵笔记》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011433427000, '王世贞', 801901011458592800, '王世贞', '15898130334', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wangshizhen@gmail.com', '', '', '王世贞（1526年－1590年）字元美，号凤洲，又号弇州山人，汉族，太仓（今江苏太仓）人，明代文学家、史学家。“后七子”领袖之一。官刑部主事，累官刑部尚书，移疾归，卒赠太子少保。好为古诗文，始于李攀龙主文盟，攀龙死，独主文坛二十年。有《弇山堂别集》、《嘉靖以来首辅传》、《觚不觚录》、《弇州山人四部稿》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011492147200, '刘克庄', 801901011517313000, '刘克庄', '15581082859', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'liukezhuang@gmail.com', '', '', '刘克庄(1187～1269) 南宋诗人、词人、诗论家。字潜夫，号后村。福建莆田人。宋末文坛领袖，辛派词人的重要代表，词风豪迈慷慨。在江湖诗人中年寿最长，官位最高，成就也最大。晚年致力于辞赋创作，提出了许多革新理论。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011550867500, '杨万里', 801901011563450400, '杨万里', '18961741677', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'yangwanli@gmail.com', '', '', '杨万里，字廷秀，号诚斋，男，汉族。吉州吉水（今江西省吉水县）人。南宋杰出诗人，与尤袤、范成大、陆游合称南宋“中兴四大诗人”、“南宋四大家”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011592810500, '苏轼', 801901011609587700, '苏轼', '18798473261', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'sushi@gmail.com', '', '', '苏轼（1037－1101），北宋文学家、书画家、美食家。字子瞻，号东坡居士。汉族，四川人，葬于颍昌（今河南省平顶山市郏县）。一生仕途坎坷，学识渊博，天资极高，诗文书画皆精。其文汪洋恣肆，明白畅达，与欧阳修并称欧苏，为“唐宋八大家”之一；诗清新豪健，善用夸张、比喻，艺术表现独具风格，与黄庭坚并称苏黄；词开豪放一派，对后世有巨大影响，与辛弃疾并称苏辛；书法擅长行书、...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011647336400, '白居易', 801901011668308000, '白居易', '18836246738', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'baijuyi@gmail.com', '', '', '白居易（772年－846年），字乐天，号香山居士，又号醉吟先生，祖籍太原，到其曾祖父时迁居下邽，生于河南新郑。是唐代伟大的现实主义诗人，唐代三大诗人之一。白居易与元稹共同倡导新乐府运动，世称“元白”，与刘禹锡并称“刘白”。白居易的诗歌题材广泛，形式多样，语言平易通俗，有“诗魔”和“诗王”之称。官至翰林学士、左赞善大夫。公元846年，白居易在洛阳逝世，葬于香山。有《白氏长庆集》传世，代表诗作有《长恨歌》、《卖炭翁》、《琵琶行》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011693473800, '胡应麟', 801901011706056700, '胡应麟', '13228841967', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'huyinglin@gmail.com', '', '', '（1551—1602）明金华府兰溪人，字元瑞，号少室山人，更号石羊生。万历间举人，久不第。筑室山中，购书四万余卷，记诵淹博，多所撰著。曾携诗谒王世贞，为世贞激赏。有《少室山房类稿》、《少室山房笔丛》、《诗薮》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011743805400, '赵蕃', 801901011760582700, '赵蕃', '18878852586', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhaofan@gmail.com', '', '', '赵蕃（1143年～1229年），字昌父，号章泉，原籍郑州。理宗绍定二年，以直秘阁致仕，不久卒。諡文节。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011785748500, '黄庭坚', 801901011798331400, '黄庭坚', '13825546127', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'huangtingjian@gmail.com', '', '', '黄庭坚（1045.8.9-1105.5.24），字鲁直，号山谷道人，晚号涪翁，洪州分宁（今江西省九江市修水县）人，北宋著名文学家、书法家，为盛极一时的江西诗派开山之祖，与杜甫、陈师道和陈与义素有“一祖三宗”（黄庭坚为其中一宗）之称。与张耒、晁补之、秦观都游学于苏轼门下，合称为“苏门四学士”。生前与苏轼齐名，世称“苏黄”。著有《山谷词》，且黄庭坚书法亦能独树一格，为“宋四家”之一。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011827691500, '范成大', 801901011840274400, '范成大', '13454134095', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'fanchengda@gmail.com', '', '', '范成大（1126-1193），字致能，号称石湖居士。汉族，平江吴县（今江苏苏州）人。南宋诗人。谥文穆。从江西派入手，后学习中、晚唐诗，继承了白居易、王建、张籍等诗人新乐府的现实主义精神，终于自成一家。风格平易浅显、清新妩媚。诗题材广泛，以反映农村社会生活内容的作品成就最高。他与杨万里、陆游、尤袤合称南宋“中兴四大诗人”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011865440300, '梅尧臣', 801901011878023200, '梅尧臣', '18679909527', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'meiyaochen@gmail.com', '', '', '梅尧臣（1002～1060）字圣俞，世称宛陵先生，北宋著名现实主义诗人。汉族，宣州宣城（今属安徽）人。宣城古称宛陵，世称宛陵先生。初试不第，以荫补河南主簿。50岁后，于皇祐三年（1051）始得宋仁宗召试，赐同进士出身，为太常博士。以欧阳修荐，为国子监直讲，累迁尚书都官员外郎，故世称“梅直讲”、“梅都官”。曾参与编撰《新唐书》，并为《孙子兵法》作注，所注为孙子十家著（或十一家著）之一。有《宛陵先生集》60卷，有《四部丛刊》影明刊本等。词存二首。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011903189000, '韩淲', 801901011915771900, '韩淲', '15540312077', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'hanbiao@gmail.com', '', '', '韩淲（biāo）（1159—1224）南宋诗人。字仲止，一作子仲，号涧泉，韩元吉之子。祖籍开封，南渡后隶籍信州上饶（今属江西）。从仕后不久即归，有诗名，著有《涧泉集》。淲清廉狷介，与同时知名诗人多有交游，并与赵蕃（章泉）并称“二泉”。著作历代书目未见著录。史弥远当国，罗致之，不为少屈。人品学问，俱有根柢，雅志绝俗，清苦自持，年甫五十即休官不仕。嘉定十七年，以时事惊心，作甲申秋三诗，得疾而卒，年六十六。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011940937700, '王安石', 801901011953520600, '王安石', '18461719893', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wanganshi@gmail.com', '', '', '王安石（1021年12月18日－1086年5月21日），字介甫，号半山，谥文，封荆国公。世人又称王荆公。汉族，北宋抚州临川人（今江西省抚州市临川区邓家巷人），中国北宋著名政治家、思想家、文学家、改革家，唐宋八大家之一。欧阳修称赞王安石：“翰林风月三千首，吏部文章二百年。老去自怜心尚在，后来谁与子争先。”传世文集有《王临川集》、《临川集拾遗》等。其诗文各体兼擅，词虽不多，但亦擅长，且有名作《桂枝香》等。...”', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901011978686500, '苏辙', 801901011991269400, '苏辙', '18658115281', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'suzhe@gmail.com', '', '', '苏辙（1039—1112年），字子由，汉族，眉州眉山（今属四川）人。嘉祐二年（1057）与其兄苏轼同登进士科。神宗朝，为制置三司条例司属官。因反对王安石变法，出为河南推官。哲宗时，召为秘书省校书郎。元祐元年为右司谏，历官御史中丞、尚书右丞、门下侍郎因事忤哲宗及元丰诸臣，出知汝州，贬筠州、再谪雷州安置，移循州。徽宗立，徙永州、岳州复太中大夫，又降居许州，致仕。自号颍滨遗老。卒，谥文定。唐宋八大家之一，与父洵、兄轼齐名，合称三苏。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012029018100, '曹勋', 801901012045795300, '曹勋', '18478643423', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'caoxun@gmail.com', '', '', '曹勋（1098—1174）字公显，一字世绩，号松隐，颍昌阳翟(今河南禹县)人。宣和五年(1123)，以荫补承信郎，特命赴进士廷试，赐甲科。靖康元年(1126)，与宋徽宗一起被金兵押解北上，受徽宗半臂绢书，自燕山逃归。建炎元年(1127)秋，至南京(今河南商丘)向宋高宗上御衣书，请求召募敢死之士，由海路北上营救徽宗。当权者不听，被黜。绍兴十一年(1141)，宋金和议成，充报谢副使出使金国，劝金人归还徽宗灵柩。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012070961200, '方回', 801901012083544000, '方回', '18751407687', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'fanghui@gmail.com', '', '', '（1227—1307）宋元间徽州歙县人，字万里，号虚谷。幼孤，从叔父学。宋理宗景定三年进士。初媚贾似道，似道败，又上十可斩之疏。后官知严州，以城降元，为建德路总管。寻罢归，遂肆意于诗。有《桐江集》、《续古今考》，又选唐宋以来律诗，为《瀛奎律髓》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012117098500, '王十朋', 801901012133875700, '王十朋', '15241380417', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wangshipeng@gmail.com', '', '', '王十朋（1112-1171），字龟龄，号梅溪，南宋著名的政治家和诗人，伟大的爱国主义者。出生于乐清四都左原（今浙江省乐清市）梅溪村。绍兴二十七年（1157年）他以“揽权”中兴为对，中进士第一，被擢为状元，先授承事郎，兼建王府小学教授。王十朋以名节闻名于世，刚直不阿，批评朝政，直言不讳。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012163235800, '周紫芝', 801901012175818800, '周紫芝', '15477339818', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhouzizhi@gmail.com', '', '', '周紫芝（1082-1155），南宋文学家。字少隐，号竹坡居士，宣城（今安徽宣州市）人。绍兴进士。高宗绍兴十五年，为礼、兵部架阁文字。高宗绍兴十七年（1147）为右迪功郎敕令所删定官。历任枢密院编修官、右司员外郎。绍兴二十一年（1151）出知兴国军（治今湖北阳新），后退隐庐山。交游的人物主要有李之仪、吕好问吕本中父子、葛立方以及秦桧等，曾向秦桧父子献谀诗。约卒于绍兴末年。著有《太仓稊米集》、《竹坡诗话》、《竹坡词》。有子周畴。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012200984600, '李梦阳', 801901012209373200, '李梦阳', '13688416231', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'limengyang@gmail.com', '', '', '李梦阳（1472-1530)，字献吉，号空同，汉族，庆阳府安化县(今甘肃省庆城县)人，迁居开封，工书法，得颜真卿笔法，精于古文词，提倡“文必秦汉，诗必盛唐”，强调复古，《自书诗》师法颜真卿，结体方整严谨，不拘泥规矩法度，学卷气浓厚。明代中期文学家，复古派前七子的领袖人物。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012234539000, '杨士奇', 801901012251316200, '杨士奇', '18532333848', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'yangshiqi@gmail.com', '', '', '杨士奇（1366～1444），明代大臣、学者，名寓，字士奇，以字行，号东里，谥文贞，汉族，江西泰和（今江西泰和县澄江镇）人。官至礼部侍郎兼华盖殿大学士，兼兵部尚书，历五朝，在内阁为辅臣四十余年，首辅二十一年。与杨荣、杨溥同辅政，并称“三杨”，因其居地所处，时人称之为“西杨”。“三杨”中，杨士奇以“学行”见长，先后担任《明太宗实录》、《明仁宗实录》、《明宣宗实录》总裁。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012293259300, '陈著', 801901012301647900, '陈著', '18997335769', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chenzhu@gmail.com', '', '', '（一二一四～一二九七），字谦之，一字子微，号本堂，晚年号嵩溪遗耄，鄞县（今浙江宁波）人，寄籍奉化。理宗宝祐四年（一二五六）进士，调监饶州商税。景定元年（一二六○），为白鹭书院山长，知安福县。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012339396600, '陈献章', 801901012385534000, '陈献章', '15637614956', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chenxianzhang@gmail.com', '', '', '（1428—1500）明广东新会人，字公甫，号石斋，晚号石翁，居白沙里，学者称白沙先生。正统十二年，两赴礼部不第。从吴与弼讲理学，居半年而归。筑阳春台，读书静坐，数年不出户。入京至国子监，祭酒邢让惊为真儒复出。成化十九年授翰林检讨，乞终养归。其学以静为主，教学者端坐澄心，于静中养出端倪。兰溪姜麟称之为“活孟子”。又工书画，山居偶乏笔，束茅代之，遂自成一家，时呼为茅笔字。画多墨梅。有《白沙诗教解》、《白沙集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012431671300, '张耒', 801901012444254200, '张耒', '18405122833', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhanglei@gmail.com', '', '', '北宋文学家，擅长诗词，为苏门四学士之一。《全宋词》《全宋诗》中有他的多篇作品。早年游学于陈，学官苏辙重爱，从学于苏轼，苏轼说他的文章类似苏辙，汪洋澹泊。其诗学白居易、张籍，如：《田家》《海州道中》《输麦行》多反映下层人民的生活以及自己的生活感受，风格平易晓畅。著作有《柯山集》五十卷、《拾遗》十二卷、《续拾遗》一卷。《宋史》卷四四四有传。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012469420000, '顾璘', 801901012482003000, '顾璘', '15422244137', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'gulin@gmail.com', '', '', '顾璘（1476～1545）明代官员、文学家。字华玉，号东桥居士，长洲（今江苏省吴县）人，寓居上元（今江苏省南京市），有知人鉴。弘治间进士，授广平知县，累官至南京刑部尚书。少有才名，以诗著称于时，与其同里陈沂、王韦号称“金陵三俊”，后宝应朱应登起，时称“四大家”。著有《浮湘集》、《山中集》、《息园诗文稿》等。其曾评注杨士弘《唐音》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012511363100, '陈恭尹', 801901012523946000, '陈恭尹', '18247373284', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chengongyin@gmail.com', '', '', '陈恭尹（1631 ～1700），字元孝，初号半峰，晚号独漉子，又号罗浮布衣，汉族，广东顺德县（今佛山顺德区）龙山乡人。著名抗清志士陈邦彦之子。清初诗人，与屈大均、梁佩兰同称岭南三大家。又工书法，时称清初广东第一隶书高手。有《独漉堂全集》，诗文各15卷，词1卷。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012544917500, '朱熹', 801901012557500400, '朱熹', '15422475615', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhuxi@gmail.com', '', '', '朱熹（1130年9月15日～1200年4月23日），行五十二，小名沋郎，小字季延，字元晦，一字仲晦，号晦庵，晚称晦翁，又称紫阳先生、考亭先生、沧州病叟、云谷老人、沧洲病叟、逆翁。谥文，又称朱文公。汉族，祖籍南宋江南东路徽州府婺源县（今江西省婺源），出生于南剑州尤溪（今属福建三明市）。南宋著名的理学家、思想家、哲学家、教育家、诗人、闽学派的代表人物，世称朱子，是孔子、孟子以来最杰出的弘扬儒学的大师。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012586860500, '胡奎', 801901012599443500, '胡奎', '18422217748', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'hukui@gmail.com', '', '', '元明间浙江海宁人，字虚白，号斗南老人。明初以儒征，官宁王府教授。有《斗南老人集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012620415000, '郭之奇', 801901012632997900, '郭之奇', '18477082327', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'guozhiqi@gmail.com', '', '', '郭之奇（1607年－1662年），字仲常，号菽子，又号正夫、玉溪。广东揭阳县榕城东门（今广东揭阳市榕城区）人。为南明大臣，历任南明文渊阁大学士加太子太保（相当宰相）兼吏部尚书、兵部尚书，率军转战闽粤滇黔抗清，于顺治十八年（1661年）在广西桂林为清将韦永福所俘，翌年殉国。清乾隆四十一年（1776年）追谥忠节。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012658163700, '卢龙云', 801901012670746600, '卢龙云', '18124632624', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lulongyun@gmail.com', '', '', '广东南海人，字少从。万历十一年进士。授马平知县，补邯郸，治行为诸县之最。复补长乐，以忤权要，左迁江西藩幕。累官至贵州布政司参议。有《四留堂稿》、《谈诗类要》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012691718100, '杜甫', 801901012704301000, '杜甫', '18188954087', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'dufu@gmail.com', '', '', '杜甫（712－770），字子美，自号少陵野老，世称“杜工部”、“杜少陵”等，汉族，河南府巩县（今河南省巩义市）人，唐代伟大的现实主义诗人，杜甫被世人尊为“诗圣”，其诗被称为“诗史”。杜甫与李白合称“李杜”，为了跟另外两位诗人李商隐与杜牧即“小李杜”区别开来，杜甫与李白又合称“大李杜”。他忧国忧民，人格高尚，他的约1400余首诗被保留了下来，诗艺精湛，在中国古典诗歌中备受推崇，影响深远。759-766年间曾居成都，后世有杜甫草堂纪念。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012725272600, '丘逢甲', 801901012737855500, '丘逢甲', '18508101545', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'qiufengjia@gmail.com', '', '', '丘逢甲(1864年～1912年）近代诗人。字仙根，又字吉甫，号蛰庵、仲阏、华严子，别署海东遗民、南武山人、仓海君。辛亥革命后以仓海为名。祖籍嘉应镇平（今广东蕉岭）。同治三年（1864年）生于台湾彰化，光绪十四年（1887年）中举人，光绪十五年登进士（1889年），授任工部主事。但丘逢甲无意在京做官返回台湾，到台湾台中衡文书院担任主讲，后又于台湾的台南和嘉义教育新学。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012763021300, '方岳', 801901012771409900, '方岳', '15773664531', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'fangyue@gmail.com', '', '', '方岳(1199～1262),南宋诗人、词人。字巨山，号秋崖。祁门（今属安徽）人。绍定五年(1232)进士，授淮东安抚司□官。淳□中，以工部郎官充任赵葵淮南幕中参议官。后调知南康军。后因触犯湖广总领贾似道，被移治邵武军。后知袁州，因得罪权贵丁大全，被弹劾罢官。后复被起用知抚州，又因与贾似道的旧嫌而取消任命。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012796575700, '欧阳修', 801901012821741600, '欧阳修', '13167726745', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'ouyangxiu@gmail.com', '', '', '欧阳修（1007－1072），字永叔，号醉翁，晚号“六一居士”。汉族，吉州永丰（今江西省永丰县）人，因吉州原属庐陵郡，以“庐陵欧阳修”自居。谥号文忠，世称欧阳文忠公。北宋政治家、文学家、史学家，与韩愈、柳宗元、王安石、苏洵、苏轼、苏辙、曾巩合称“唐宋八大家”。后人又将其与韩愈、柳宗元和苏轼合称“千古文章四大家”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012851101700, '刘敞', 801901012863684600, '刘敞', '15654263748', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'liuchang@gmail.com', '', '', '刘敞（1019—1068）北宋史学家、经学家、散文家。字原父，一作原甫，临江新喻荻斜（今属江西樟树）。庆历六年与弟刘攽同科进士，以大理评事通判蔡州，后官至集贤院学士。与梅尧臣、欧阳修交往较多。为人耿直，立朝敢言，为政有绩，出使有功。刘敞学识渊博，欧阳修说他“自六经百氏古今传记，下至天文、地理、卜医、数术、浮图、老庄之说，无所不通；其为文章尤敏赡”，与弟刘攽合称为北宋二刘，著有《公是集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012884656100, '释居简', 801901012897239000, '释居简', '18341263076', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shijujian@gmail.com', '', '', '释居简（一一六四～一二四六），字敬叟，号北涧，潼川（今四川三台）人。俗姓龙（《补续高僧传》卷二四作王）。依邑之广福院圆澄得度，参别峰涂毒于径山，谒育王佛照德光，走江西访诸祖遗迹。历住台之般若报恩。后居杭之飞来峰北涧十年。起应霅之铁佛、西余，常之显庆、碧云，苏之慧日，湖之道场，诏迁净慈，晚居天台。理宗淳祐六年卒，年八十三，僧腊六十二。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012918210600, '邵宝', 801901012930793500, '邵宝', '18144391441', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shaobao@gmail.com', '', '', '邵宝（1460-1527）字国宝，号二泉，江苏无锡人，成化二十年（1484）进士，历为江西提学副使，官至南京礼部尚书，谥文庄。文典重和雅，诗清和淡薄。著有《简端二馀》《慧山记》《容春堂集》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012951765000, '陈维崧', 801901012968542200, '陈维崧', '18618500019', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chenweisong@gmail.com', '', '', '陈维崧(1625～1682)清代词人、骈文作家。字其年，号迦陵。宜兴（今属江苏）人。清初诸生，康熙十八年(1679)举博学鸿词，授翰林院检讨。54岁时参与修纂《明史》，4年后卒于任所。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901012993708000, '徐熥', 801901013006291000, '徐熥', '13468922780', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'xuteng@gmail.com', '', '', '福建闽县人，字惟和。徐', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013031456800, '黎民表', 801901013048234000, '黎民表', '15662326222', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'liminbiao@gmail.com', '', '', '明广东从化人，字惟敬，号瑶石山人。黎贯子。黄佐弟子。以诗名，与王道行、石星、朱多煃、赵用贤称“续五子”。亦工书画。嘉靖举人。选入内阁，为制敕房中书舍人，出为南京兵部车驾员外郎。万历中官至河南布政司参议。有《瑶石山人稿》、《养生杂录》、《谕后语录》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013077594100, '袁宏道', 801901013090177000, '袁宏道', '18597912218', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'yuanhongdao@gmail.com', '', '', '袁宏道（1568～1610）明代文学家，字中郎，又字无学，号石公，又号六休。汉族，荆州公安（今属湖北公安）人。宏道在文学上反对“文必秦汉，诗必盛唐”的风气，提出“独抒性灵，不拘格套”的性灵说。与其兄袁宗道、弟袁中道并有才名，合称“公安三袁”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013115342800, '邵雍', 801901013127925800, '邵雍', '15952652416', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shaoyong@gmail.com', '', '', '邵雍（1011年—1077年），字尧夫，生于范阳（今河北涿州大邵村），幼年随父邵古迁往衡漳（今河南林县康节村），天圣四年（1026年），邵雍16岁，随其父到共城苏门山，卜居于此地。后师从李之才学《河图》、《洛书》与伏羲八卦，学有大成，并著有《皇极经世》、《观物内外篇》、《先天图》、《渔樵问对》、《伊川击壤集》、《梅花诗》等。嘉祐七年（1062年），移居洛阳天宫寺西天津桥南，自号安乐先生。出游时必坐一小车，由一人牵拉。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013148897300, '何景明', 801901013157285900, '何景明', '15845583161', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'hejingming@gmail.com', '', '', '何景明（1483～1521）字仲默，号白坡，又号大复山人，信阳浉河区人。明弘治十五年(1502)进士，授中书舍人。正德初，宦官刘瑾擅权，何景明谢病归。刘瑾诛，官复原职。官至陕西提学副使。为“前七子”之一，与李梦阳并称文坛领袖。其诗取法汉唐，一些诗作颇有现实内容。有《大复集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013182451700, '顾清', 801901013199228900, '顾清', '15672793146', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'guqing@gmail.com', '', '', '顾清（1460-1528）字士廉，江南华亭人，弘治六年（1493）进士，官至南京礼部尚书。诗清新婉丽，天趣盎然。著有《东江家藏集》《松江府志》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013232783400, '区大相', 801901013245366300, '区大相', '15487812276', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'qudaxiang@gmail.com', '', '', '广东高明人，字用儒，号海目。区益子。善为文，下笔千言立就。万历十七年进士。初选庶吉士，累迁赞善、中允。掌制诰。居翰院十五年，与赵志皋、张位、沈一贯等有旧。赵等先后当国，大相皆引避不轻谒。后调南太仆寺丞，以疾归，卒。工诗词，皆严于格律，为明代岭南大家。有《太史集》、《图南集》、《濠上集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013278920700, '王之道', 801901013287309300, '王之道', '13734255173', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wangzhidao@gmail.com', '', '', '公元一〇九三年至一一六九年字彦猷，庐州濡须人。生于宋哲宗元祐八年，卒于孝宗乾道五年，年七十七岁。善文，明白晓畅，诗亦真朴有致。为人慷慨有气节。宣和六年，（公元一一二四年）与兄之义弟之深同登进士第。对策极言燕云用兵之非，以切直抑制下列。调历阳丞。绍兴和议初成，之道方通判滁州，力陈辱国非便。大忤秦桧意，谪监南雄盐税。坐是沦废者二十年。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013312475100, '刘基', 801901013320863700, '刘基', '15477712314', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'liuji@gmail.com', '', '', '刘基（1311年7月1日－1375年5月16日）字伯温，谥曰文成，元末明初杰出的军事谋略家、政治家、文学家和思想家，明朝开国元勋，汉族，浙江文成南田（原属青田）人，故时人称他刘青田，明洪武三年（1370）封诚意伯，人们又称他刘诚意。武宗正德九年追赠太师，谥号文成，后人又称他刘文成、文成公。他以神机妙算、运筹帷幄著称于世。刘伯温是中国古代的一位传奇人物，至今在中国大陆、港澳台乃至东南亚、日韩等地仍有广泛深厚的民间影响力。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013367001100, '湛若水', 801901013383778300, '湛若水', '18332797996', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhanruoshui@gmail.com', '', '', '（1466—1560）广东增城人，字元明，号甘泉。少师事陈献章。弘治十八年进士，授编修。历南京国子监祭酒，南京吏、礼，兵三部尚书。在翰林院时与王守仁同时讲学，主张“随处体认天理”，“知行并进”，反对“知先行后”，与阳明之说有所不同。后筑西樵讲舍讲学，学者称甘泉先生。卒谥文简。著有《心性图说》、《格物通》、《甘泉集》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013413138400, '皇甫汸', 801901013425721300, '皇甫汸', '15917305268', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'huangfufang@gmail.com', '', '', '（1497—1582）明苏州长洲人，字子循，号百泉。皇甫录第三子。嘉靖八年进士，授工部主事，官至云南佥事，以计典论黜。好声色狎游。工诗，尤精书法。有《百泉子绪论》、《解颐新语》、《皇甫司勋集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013446692900, '王夫之', 801901013459275800, '王夫之', '13333883861', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wangfuzhi@gmail.com', '', '', '王夫之（1619年10月7日－1692年2月18日），字而农，号姜斋、又号夕堂，湖广衡州府衡阳县（今湖南衡阳）人。他与顾炎武、黄宗羲并称明清之际三大思想家。其著有《周易外传》、《黄书》、《尚书引义》、《永历实录》、《春秋世论》、《噩梦》、《读通鉴论》、《宋论》等书。王夫之自幼跟随自己的父兄读书，青年时期王夫之积极参加反清起义，晚年王夫之隐居于石船山，著书立传，自署船山病叟、南岳遗民，学者遂称之为船山先生。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013480247300, '李白', 801901013505413100, '李白', '15428431857', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'libai@gmail.com', '', '', '李白（701年－762年），字太白，号青莲居士，唐朝浪漫主义诗人，被后人誉为“诗仙”。祖籍陇西成纪(待考)，出生于西域碎叶城，4岁再随父迁至剑南道绵州。李白存世诗文千余篇，有《李太白集》传世。762年病逝，享年61岁。其墓在今安徽当涂，四川江油、湖北安陆有纪念馆。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013534773200, '李东阳', 801901013547356200, '李东阳', '15104371904', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lidongyang@gmail.com', '', '', '李东阳（1447年－1516年），字宾之，号西涯，谥文正，明朝中叶重臣，文学家，书法家，茶陵诗派的核心人物。湖广长沙府茶陵州（今湖南茶陵）人，寄籍京师（今北京市）。天顺八年进士，授编修，累迁侍讲学士，充东宫讲官，弘治八年以礼部侍郎兼文渊阁大学士，直内阁，预机务。立朝五十年，柄国十八载，清节不渝。文章典雅流丽，工篆隶书。有《怀麓堂集》、《怀麓堂诗话》、《燕对录》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013572522000, '徐渭', 801901013585104900, '徐渭', '15725101476', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'xuwei@gmail.com', '', '', '徐渭（1521—1593），汉族，绍兴府山阴（今浙江绍兴）人。初字文清，后改字文长，号天池山人，或署田水月、田丹水，青藤老人、青藤道人、青藤居士、天池渔隐、金垒、金回山人、山阴布衣、白鹇山人、鹅鼻山侬等别号。中国明代文学家、书画家、军事家。民间也普遍流传他的故事传说，关于他年轻时如何聪明，后来如何捉弄官宦等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013606076400, '杨慎', 801901013618659300, '杨慎', '18786382302', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'yangshen@gmail.com', '', '', '杨慎（1488～1559）明代文学家，明代三大才子之首。字用修，号升庵，后因流放滇南，故自称博南山人、金马碧鸡老兵。杨廷和之子，汉族，四川新都（今成都市新都区）人，祖籍庐陵。正德六年状元，官翰林院修撰，豫修武宗实录。武宗微行出居庸关，上疏抗谏。世宗继位，任经筵讲官。嘉靖三年，因“大礼议”受廷杖，谪戍终老于云南永昌卫。终明一世记诵之博，著述之富，慎可推为第一。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013643825200, '陈造', 801901013656408000, '陈造', '13749525214', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chenzao@gmail.com', '', '', '陈造（1133年～1203年）字唐卿，高邮（今属江苏）人。生于宋高宗绍兴三年，孝宗淳熙二年（1175年）进士，以词赋闻名艺苑，撰《芹宫讲古》，阐明经义，人称“淮南夫子”。范成大见其诗文谓“使遇欧、苏，盛名当不在少游下。”尤袤、罗点得其骚词、杂著，爱之手不释卷。郑兴裔荐其“问学闳深，艺文优赡”。调太平州繁昌尉，改平江府教授，寻知明州定海县，通判房州权知州事。房州秩满，...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013677379600, '边贡', 801901013689962500, '边贡', '13859702057', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'biangong@gmail.com', '', '', '边贡（1476 ～1532）字庭实，因家居华泉附近，自号华泉子，历城（今山东济南市）人。明代著名诗人、文学家。弘治九年（1496）丙辰科进士，官至太常丞。边贡以诗著称于弘治、正德年间，与李梦阳、何景明、徐祯卿并称“弘治四杰”。后来又加上康海、王九思、王廷相，合称为明代文学“前七子”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013710934000, '宋祁', 801901013719322600, '宋祁', '15533092166', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'songqi@gmail.com', '', '', '宋祁（998～1061）北宋文学家。字子京，安州安陆（今湖北安陆）人，后徙居开封雍丘（今河南杞县）。天圣二年进士，官翰林学士、史馆修撰。与欧阳修等合修《新唐书》，书成，进工部尚书，拜翰林学士承旨。卒谥景文，与兄宋庠并有文名，时称“二宋”。诗词语言工丽，因《玉楼春》词中有“红杏枝头春意闹”句，世称“红杏尚书”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013744488400, '郭祥正', 801901013752877000, '郭祥正', '15797559133', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'guoxiangzheng@gmail.com', '', '', '郭祥正（1035～1113）北宋诗人。字功父，一作功甫，自号谢公山人、醉引居士、净空居士、漳南浪士等。当涂（今属安徽）人。皇祐五年进士，历官秘书阁校理、太子中舍、汀州通判、朝请大夫等，虽仕于朝，不营一金，所到之处，多有政声。一生写诗1400余首，著有《青山集》30卷。他的诗风纵横奔放，酷似李白。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013786431500, '释函可', 801901013794820100, '释函可', '13774241117', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shihanke@gmail.com', '', '', '释函可（1611-1659），字祖心，号剩人，俗姓韩，名宗騋，广东博罗人。他是明代最后一位礼部尚书韩日缵的长子。明清之际著名诗僧。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013828374500, '郑孝胥', 801901013836763100, '郑孝胥', '18434665331', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhengxiaoxu@gmail.com', '', '', '郑孝胥，（1860年5月2日——1938年）字苏龛（苏堪），一字太夷,号海藏，尝取东坡‘万人如海一身藏’诗意，颜所居曰‘海藏楼’，世称‘郑海藏’。中国福建省闽侯县人。工诗，擅书法，为诗坛“同光体”宣导者之一。著有《海藏楼诗集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013857734700, '司马光', 801901013870317600, '司马光', '18474441288', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'simaguang@gmail.com', '', '', '司马光（1019年11月17日－1086年），字君实，号迂叟，陕州夏县（今山西夏县）涑水乡人，《宋史》，《辞海》等明确记载，世称涑水先生。生于河南省信阳市光山县。北宋史学家、文学家。历仕仁宗、英宗、神宗、哲宗四朝，卒赠太师、温国公，谥文正，主持编纂了中国历史上第一部编年体通史《资治通鉴》，为人温良谦恭、刚正不阿，其人格堪称儒学教化下的典范，历来受人景仰。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013891289100, '李攀龙', 801901013908066300, '李攀龙', '15226573640', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lipanlong@gmail.com', '', '', '李攀龙（1514—1570）字于鳞，号沧溟，汉族，历城（今山东济南）人。明代著名文学家。继“前七子”之后，与谢榛、王世贞等倡导文学复古运动，为“后七子”的领袖人物，被尊为“宗工巨匠”。主盟文坛20余年，其影响及于清初。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013929037800, '吴与弼', 801901013941620700, '吴与弼', '15450045410', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wuyubi@gmail.com', '', '', '（1391—1469）江西崇仁人，初名梦祥，字子傅，吴溥子。十九岁即决心专治程朱理学，不应科举。天顺元年以石亨荐，授左谕德，固辞不拜。所著《日录》，悉言生平所得。胡居仁、陈献章、娄谅等均其弟子。学者称康斋先生，有《康斋文集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901013975175200, '吕本中', 801901013991952400, '吕本中', '18126955318', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lvbenzhong@gmail.com', '', '', '吕本中（1084- 1145），字居仁，世称东莱先生，寿州人，诗人，词人，道学家. 诗属江西派.著有&lt;&lt;春秋集解&gt;&gt;，&lt;&lt;紫微诗话&gt;&gt;，&lt;&lt;东莱先生诗集&gt;&gt; 等. 词不传，今人赵万里&lt;&lt;校辑宋金元人词&gt;&gt; 辑有&lt;&lt;紫微词&gt;&gt;，&lt;&lt;全宋词&gt;&gt; 据之录词二十七首.吕本中诗数量较大，约一千二百七十首。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014021312500, '薛瑄', 801901014033895400, '薛瑄', '18714240165', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'xuexuan@gmail.com', '', '', '薛瑄（1389年8月20日—1464年7月19日），字德温，号敬轩。河津（今山西省运城市万荣县里望乡平原村人）人。明代著名思想家、理学家、文学家，河东学派的创始人，世称“薛河东”。薛瑄继曹端之后，在北方开创了“河东之学”，门徒遍及山西、河南、关陇一带，蔚为大宗。其学传至明中期，又形成以吕大钧兄弟为主的“关中之学”，其势“几与阳明中分其感”。清人视薛学为朱学传宗，称之为“明初理学之冠”，...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014054867000, '吴芾', 801901014067449900, '吴芾', '15420627351', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wufei@gmail.com', '', '', '吴芾（1104—1183），字明可，号湖山居士，浙江台州府人（现今浙江省台州市仙居县田市吴桥村）人。绍兴二年（1132）进士，官秘书正字，因揭露秦桧卖国专权被罢官。后任监察御史，上疏宋高宗自爱自强、励精图治。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014092615700, '王恭', 801901014101004300, '王恭', '15780153427', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'wanggong@gmail.com', '', '', '王恭(1343-? )，字安仲，长乐沙堤人。家贫，少游江湖间，中年隐居七岩山，为樵夫20多年，自号“皆山樵者”。善诗文，与高木秉、陈亮等诸文士唱和，名重一时。诗人王 曾为他作《皆山樵者传》。明永乐二年(1404年)，年届六十岁的王恭以儒士荐为翰林待诏，敕修《永乐大典》。永乐五年，《永乐大典》修成，王恭试诗高第，授翰林典籍。不久，辞官返里。王恭作诗，才思敏捷，下笔千言立就，诗风多凄婉，隐喻颇深。为闽中十才子之一，著有《白云樵集》四卷，《草泽狂歌》五卷及《风台清啸》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014126170100, '释今无', 801901014134558700, '释今无', '18610112683', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shijinwu@gmail.com', '', '', '今无（一六三三—一六八一），字阿字。番禺人。本万氏子，年十六，参雷峰函是，得度。十七受坛经，至参明上座因缘，闻猫声，大彻宗旨。监栖贤院务，备诸苦行，得遍阅内外典。十九随函是入庐山，中途寒疾垂死，梦神人导之出世，以钝辞，神授药粒，觉乃苏，自此思如泉涌，通三教，年二十二奉师命只身走沈阳，谒师叔函可，相与唱酬，可亟称之。清圣祖康熙十二年（一六七三）...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014163918800, '李孙宸', 801901014172307500, '李孙宸', '18585168471', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lisunchen@gmail.com', '', '', '明广东香山人，字伯襄。万历四十一年进士。教习庶吉士。崇祯间官至南京礼部尚书。性孝友廉介。诗祖《三百篇》，书法祖魏晋，草篆隶楷皆工。有《建霞楼集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014197473300, '刘攽', 801901014205861900, '刘攽', '18877432548', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'liuban@gmail.com', '', '', '刘攽bān（1023～1089）北宋史学家，刘敞之弟。字贡夫，一作贡父、赣父，号公非。临江新喻（今江西新余）人，一说江西樟树人。庆历进士，历任曹州、兖州、亳州、蔡州知州，官至中书舍人。一生潜心史学，治学严谨。助司马光纂修《资治通鉴》，充任副主编，负责汉史部分，著有《东汉刊误》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014226833400, '黄衷', 801901014235222000, '黄衷', '15761533238', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'huangzhong@gmail.com', '', '', '明广东南海人，字子和。弘治九年进士。授南京户部主事，监江北诸仓，清查积年侵羡，得粟十余万石。历户部员外郎、湖州知府、晋广西参政，督粮严法绳奸，境内肃然。后抚云南，镇湖广皆有政绩。官至兵部右侍郎。致仕卒，年八十。有《海语》、《矩洲集》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014256193500, '戴亨', 801901014268776400, '戴亨', '13406240527', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'daiheng@gmail.com', '', '', '戴亨，字通乾，号遂堂，汉军旗人。康熙辛丑进士，官齐河知县。有《庆芝堂诗集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014293942300, '辛弃疾', 801901014306525200, '辛弃疾', '13952738322', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'xinqiji@gmail.com', '', '', '辛弃疾（1140－1207），南宋词人。原字坦夫，改字幼安，别号稼轩，汉族，历城（今山东济南）人。出生时，中原已为金兵所占。21岁参加抗金义军，不久归南宋。历任湖北、江西、湖南、福建、浙东安抚使等职。一生力主抗金。曾上《美芹十论》与《九议》，条陈战守之策。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014327496700, '晁补之', 801901014340079600, '晁补之', '18647556841', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chaobuzhi@gmail.com', '', '', '晁补之（公元1053年—公元1110年），字无咎，号归来子，汉族，济州巨野（今属山东巨野县）人，北宋时期著名文学家。为“苏门四学士”（另有北宋诗人黄庭坚、秦观、张耒）之一。曾任吏部员外郎、礼部郎中。 工书画，能诗词，善属文。与张耒并称“晁张”。其散文语言凝练、流畅，风格近柳宗元。诗学陶渊明。其词格调豪爽，语言清秀晓畅，近苏轼。但其诗词流露出浓厚的消极归隐思想。著有《鸡肋集》、《晁氏琴趣外篇》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014365245400, '洪咨夔', 801901014382022700, '洪咨夔', '15421287555', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'hongzikui@gmail.com', '', '', '洪咨夔，(1176～1236)，南宋诗人，汉族人。字舜俞，号平斋。於潜（今属浙江临安县）人。嘉泰二年(1202)进士。授如皋主簿，寻为饶州教授。作《大治赋》，受到楼钥赏识。著作有《春秋说》3卷、《西汉诏令揽钞》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014407188500, '谢榛', 801901014419771400, '谢榛', '13158681776', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'xiezhen@gmail.com', '', '', '谢榛（1495～1575）明代布衣诗人。字茂秦，号四溟山人、脱屣山人，山东临清人。十六岁时作乐府商调，流传颇广，后折节读书，刻意为歌诗，以声律有闻于时。嘉靖间，挟诗卷游京师，与李攀龙、王世贞等结诗社，为“后七子”之一，倡导为诗摹拟盛唐，主张“选李杜十四家之最者，熟读之以夺神气，歌咏之以求声调，玩味之以裒精华。”后为李攀龙排斥，削名“七子”之外，客游诸藩王间，以布衣终其身。其诗以律句绝句见长，功力深厚，句响字稳，著有《四溟集》、《四溟诗话》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014440742900, '韦骧', 801901014453325800, '韦骧', '18901582381', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'weixiang@gmail.com', '', '', '公元一〇三三年至一一一〇五年，字子骏，钱塘人。生于宋仁宗明道二年，卒于徽宗崇宁四年，年七十三岁。工诗文。皇祐五年（公元一0五三年）进士，除知袁州萍乡系。历福建转连判官，主客郎中。出为变路提刑。建中靖国初，（公元一一〇一年）除知明州丐宫祠，以左朝议大夫提举洞霄宫，卒。骧著有文集十八卷，赋二十卷，均《宋史艺文志》并传于世。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014474297300, '韩维', 801901014486880300, '韩维', '13204425728', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'hanwei@gmail.com', '', '', '韩维（1017年～1098年），字持国，开封雍丘（今河南杞县）人。韩亿子，与韩绛、韩缜等为兄弟。以父荫为官，父死后闭门不仕。仁宗时由欧阳修荐知太常礼院，不久出通判泾州。为淮阳郡王府记室参军。英宗即位，召为同修起居注，进知制诰、知通进银台司。神宗熙宁二年（1069年）迁翰林学士、知开封府。因与王安石议论不合，出知襄州，改许州，历河阳，复知许州。哲宗即位，召为门下侍郎，一年馀出知邓州，改汝州，以太子少傅致仕。绍圣二年（1095年）定为元祐党人，...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014507851800, '李曾伯', 801901014520434700, '李曾伯', '18215312684', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lizengbo@gmail.com', '', '', '李曾伯(1198～1265至1275间) 南宋词人。字长孺，号可斋。原籍覃怀（今河南沁阳附近）。南渡后寓居嘉兴（今属浙江）。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014541406200, '彭汝砺', 801901014553989100, '彭汝砺', '18222866724', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'pengruli@gmail.com', '', '', '彭汝砺，字器资，祖籍江西袁州区，饶州鄱阳（今江西鄱阳滨田村）人，生于宋仁宗康定二年（1041），卒于宋哲宗绍圣二年（1095）。宋英宗治平二年（1065）乙巳科状元。彭汝砺读书为文，志于大者；言行取舍，必合于义；与人交往，必尽试敬；而为文命词典雅，有古人之风范。著有《易义》、《诗义》、《鄱阳集》等。彭汝砺去世后被安葬在江西省鄱阳县双港镇，其后裔以鄱阳滨田，双港为中心，散居全国各省市等地。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014579155000, '释文珦', 801901014587543600, '释文珦', '18862469557', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shiwenxiang@gmail.com', '', '', '释文珦（一二一〇——？）（生年据本集卷一〇《看新历》“又看景定新颁历，百岁还惊五十过”推定），字叔向（影印《诗渊》册五页三七九八《宿山庵》署），自号潜山老叟，于潜（今浙江临安西南）人。早岁出家，遍游东南各地，游踪略见集中《闲中多暇追叙旧游成一百十韵》诗，有“题咏诗三百，经行路四千”之句，后以事下狱，久之得免，遂遁迹不出。终年八十馀。诗集已佚，清四库馆臣据《永乐大典》辑为《潜山集》十二卷。事见集中有关诗篇。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014608515100, '张宁', 801901014621098000, '张宁', '18423954303', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhangning@gmail.com', '', '', '张宁（1426—1496）字靖之，号方洲，一作芳洲，浙江海盐人，明朝中期大臣。景泰五年进士，授礼科给事中。丰采甚著，与岳正齐名，英宗尝称为“我张宁”云。成化中出知汀州，先教后刑，境内利病悉罢行之。后为大臣所忌，弃官归，公卿交荐，不起。能诗画、善书法，著有《方洲集》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014642069500, '李之仪', 801901014650458100, '李之仪', '15637872432', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'lizhiyi@gmail.com', '', '', '李之仪(1038～1117）北宋词人。字端叔，自号姑溪居士、姑溪老农。汉族，沧州无棣（庆云县）人。哲宗元祐初为枢密院编修官，通判原州。元祐末从苏轼于定州幕府，朝夕倡酬。元符中监内香药库，御史石豫参劾他曾为苏轼幕僚，不可以任京官，被停职。徽宗崇宁初提举河东常平。后因得罪权贵蔡京，除名编管太平州（今安徽当涂），后遇赦复官，晚年卜居当涂。著有《姑溪词》一卷、《姑溪居士前集》五十卷和《姑溪题跋》二卷。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014675624000, '齐己', 801901014684012500, '齐己', '18279477874', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'qiji@gmail.com', '', '', '齐己（863年—937年）出家前俗名胡德生，晚年自号衡岳沙门，湖南长沙宁乡县祖塔乡人，唐朝晚期著名诗僧。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014704984000, '魏了翁', 801901014713372700, '魏了翁', '15516078516', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'weileweng@gmail.com', '', '', '魏了翁（1178年—1237年） ，字华父，号鹤山，邛州蒲江（今属四川）人。南宋著名理学家、思想家、大臣。嘉熙元年（1237年）卒，年六十，赠太师、秦国公，谥文靖。魏了翁反对佛、老“无欲”之说，认为圣贤只言“寡欲”不言“无欲”，指出“虚无，道之害也”。推崇朱熹理学，但也怀疑朱注各经是否完全可靠。提出“心者人之太极，而人心已又为天地之太极”，强调“心”的作用，又和陆九渊接近。能诗词，善属文，其词语意高旷，风格或清丽，或悲壮。...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014734344200, '郑善夫', 801901014746927100, '郑善夫', '18741368574', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhengshanfu@gmail.com', '', '', '（1485—1523）福建闽县人，字继之，号少谷。弘治十八年进士。授户部主事，榷税浒墅。愤嬖幸用事，弃官归。正德中，起礼部主事，进员外郎。谏南巡，受廷杖，力请归。嘉靖初，以荐起为南京吏部郎中，途中病死。工画善诗。有《少谷集》、《经世要谈》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014776287200, '庄昶', 801901014788870100, '庄昶', '18375847878', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhuangchang@gmail.com', '', '', '庄昶（1437～1499）明代官员、学者。字孔暘，一作孔阳、孔抃，号木斋，晚号活水翁，学者称定山先生，汉族，江浦孝义（今江苏南京浦口区东门镇）人。成化二年进士，历翰林检讨。因反对朝庭灯彩焰火铺张浪费，不愿进诗献赋粉饰太平，与章懋、黄仲昭同谪，人称翰林四谏。被贬桂阳州判官，寻改南京行人司副。以忧归，卜居定山二十余年。弘治间，起为南京吏部郎中。罢归卒，追谥文节。昶诗仿击壤集之体。撰有《庄定山集》十卷。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014809841700, '沈周', 801901014822424600, '沈周', '18709768531', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'shenzhou@gmail.com', '', '', '沈周（1427～1509）明代杰出书画家。字启南，号石田、白石翁、玉田生、有居竹居主人等。汉族，长洲（今江苏苏州）人。生於明宣德二年，卒於明正德四年，享年八十三岁。不应科举，专事诗文、书画，是明代中期文人画“吴派”的开创者，与文徵明、唐寅、仇英并称“明四家”。传世作品有《庐山高图》、《秋林话旧图》、《沧州趣图》。著有《石田集》、《客座新闻》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014843396100, '张弼', 801901014855979000, '张弼', '15735625393', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhangbi@gmail.com', '', '', '（1425—1487）明松江府华亭人，字汝弼，号东海。成化二年进士。久任兵部郎，议论无所顾忌。出为南安知府，律己爱物，大得民和。少善草书，工诗文，自言吾书不如诗，诗不如文。有《鹤城稿》、《东海稿》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014876950500, '刘禹锡', 801901014885339100, '刘禹锡', '15315362386', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'liuyuxi@gmail.com', '', '', '刘禹锡（772－842），字梦得，汉族，中国唐朝彭城（今徐州）人，祖籍洛阳，唐朝文学家，哲学家，自称是汉中山靖王后裔，曾任监察御史，是王叔文政治改革集团的一员。唐代中晚期著名诗人，有“诗豪”之称。他的家庭是一个世代以儒学相传的书香门第。政治上主张革新，是王叔文派政治革新活动的中心人物之一。后来永贞革新失败被贬为朗州司马（今湖南常德）。据湖南常德历史学家、收藏家周新国先生考证刘禹锡被贬为朗州司马其间写了著名的“汉寿城春望”。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014906310700, '全祖望', 801901014918893600, '全祖望', '15858836673', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'quanzuwang@gmail.com', '', '', '全祖望（1705-1755），清代著名史学家、文学家，浙东学派重要代表，字绍衣，号谢山，学者称谢山先生，浙江鄞县（今鄞州区洞桥镇沙港村）人。曾主讲于浙江蕺山书院，广东端溪书院。上承清初黄宗羲经世致用之学，博通经史，在学术上推崇黄宗羲、万斯同，于南明史实广为搜罗纂述，贡献甚大，其著作极为丰富，达35部，400多卷，且大多数学术著作用力极深。其主要著作有：《鲒埼亭集》、...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014939865100, '张昱', 801901014948253700, '张昱', '13882687372', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhangyu@gmail.com', '', '', '元明间庐陵人，字光弼，号一笑居士，又号可闲老人。历官江浙行省左、右司员外郎，行枢密院判官。晚居西湖寿安坊，屋破无力修理。明太祖征至京，厚赐遣还。卒年八十三。有《庐陵集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901014969225200, '白玉蟾', 801901014977613800, '白玉蟾', '18740376030', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'baiyuchan@gmail.com', '', '', '白玉蟾（1194 - ？），南宋时人，祖籍福建闽清，生于海南琼州，内丹理论家。南宗的实际创立者，创始金丹派南宗，金丹派南五祖之一。生卒年待考，原名葛长庚，本姓葛，名长庚。字如晦，号琼琯，自称神霄散史，海南道人，琼山老人，武夷散人。幼聪慧，谙九经，能诗赋，长于书画，12岁时举童子科，作《织机》诗；才华横溢，著作甚丰。自幼从陈楠学丹法，嘉定五年（1212）八月秋，再遇陈楠于罗浮山，得授金丹火候诀并五雷大法。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015002779600, '陈子升', 801901015011168300, '陈子升', '18848413578', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chenzisheng@gmail.com', '', '', '（1614—1673）明末清初广东南海人，字乔生。陈子壮弟。明诸生。南明永历时任兵科右给事中，广东陷落后，流亡山泽间。工诗善琴。有《中洲草堂遗集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015032139800, '黄省曾', 801901015044722700, '黄省曾', '18213480461', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'huangshengzeng@gmail.com', '', '', '（1490—1540）明苏州府吴县人，字勉之，号五岳。黄鲁曾弟。通《尔雅》。嘉靖十年，以《春秋》魁乡榜，而会试累不第。从王守仁、湛若水游，又学诗于李梦阳，以任达跅弛终其身。有《西洋朝贡典录》、《拟诗外传》、《客问》、《骚苑》、《五岳山人集》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015065694200, '洪适', 801901015078277100, '洪适', '18726838033', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'hongshi@gmail.com', '', '', '洪适（1117～1184）南宋金石学家、诗人、词人。初名造，字温伯，又字景温；入仕后改名适，字景伯；晚年自号盘洲老人，饶州鄱阳（今江西省波阳县）人，洪皓长子，累官至尚书右仆射、同中书门下平章事兼枢密使，封魏国公，卒谥文惠。洪适与弟弟洪遵、洪迈皆以文学负盛名，有“鄱阳英气钟三秀”之称。同时，他在金石学方面造诣颇深，与欧阳修、赵明诚并称为宋代金石三大家。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015099248600, '张元凯', 801901015111831600, '张元凯', '18553638651', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'zhangyuankai@gmail.com', '', '', '苏州吴县人，字左虞。少习《毛诗》。以世职为苏州卫指挥，督运漕粮北上，有功不得叙，自免归。悒悒不得志，以酒自放，酒酣谈天下事，慷慨风发。工诗，有《伐檀斋集》。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015132803100, '杨维桢', 801901015145386000, '杨维桢', '13433611554', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'yangweizhen@gmail.com', '', '', '杨维桢（1296—1370）元末明初著名诗人、文学家、书画家和戏曲家。字廉夫，号铁崖、铁笛道人，又号铁心道人、铁冠道人、铁龙道人、梅花道人等，晚年自号老铁、抱遗老人、东维子，会稽（浙江诸暨）枫桥全堂人。与陆居仁、钱惟善合称为“元末三高士”。杨维祯的诗，最富特色的是他的古乐府诗，既婉丽动人，...', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015170551800, '秦观', 801901015178940400, '秦观', '13339871535', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'qinguan@gmail.com', '', '', '秦观（1049-1100）字太虚，又字少游，别号邗沟居士，世称淮海先生。汉族，北宋高邮（今江苏）人，官至太学博士，国史馆编修。秦观一 生坎坷，所写诗词，高古沉重，寄托身世，感人至深。秦观生前行踪所至之处，多有遗迹。如浙江杭州的秦少游祠，丽水的秦少游塑像、淮海先生祠、莺花亭；青田的秦学士祠；湖南郴州三绝碑；广西横县的海棠亭、醉乡亭、淮海堂、淮海书院等。秦观墓在无锡惠山之北粲山上，墓碑上书“秦龙图墓”几个大字。有秦家村、秦家大院以及省级文物保护单位古文游台。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015199912000, '高启', 801901015212494800, '高启', '15434294486', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'gaoqi@gmail.com', '', '', '高启（1336－1373）汉族，江苏苏州人，元末明初著名诗人，与杨基、张羽、徐贲被誉为“吴中四杰”，当时论者把他们比作“明初四杰”，又与王行等号“北郭十友”。字季迪，号槎轩，平江路（明改苏州府）长洲县（今江苏省苏州市）人；洪武初，以荐参修《元史》，授翰林院国史编修官，受命教授诸王。擢户部右侍郎。苏州知府魏观在张士诚宫址改修府治，获罪被诛。高启曾为之作《上梁文》，有“龙蟠虎踞”四字，被疑为歌颂张士诚，连坐腰斩。有《高太史大全集》、《凫藻集》等。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
INSERT INTO `t_user_info` VALUES (801901015233466400, '陈宝琛', 801901015241855000, '陈宝琛', '15341873710', '1', 'https://moose-plus.oss-cn-shenzhen.aliyuncs.com/2020-12-22/qr_logo.jpg', 'chenbaochen@gmail.com', '', '', '陈宝琛（1848—1935年），字伯潜，号弢庵、陶庵、听水老人。汉族，福建闽县（今福州市）螺洲人。刑部尚书陈若霖曾孙，晚清大臣，学者，官至正红旗汉军副都统、内阁弼德院顾问大臣，为毓庆宫宣统皇帝授读。中法战争后因参与褒举唐炯、徐延投统办军务失当事，遭部议连降九级，从此投闲家居达二十五年之久。赋闲期间，热心家乡教育事业。宣统元年（1909年），复调京充礼学馆总裁，辛亥革命后仍为溥仪之师，1935年卒于京寓，得逊清“文忠”谥号及“太师”觐赠 。', '2021-01-21 19:55:22', '2021-01-21 19:55:22');
COMMIT;

-- ----------------------------
-- Table structure for t_message_record
-- ----------------------------
DROP TABLE IF EXISTS `t_message_record`;
CREATE TABLE `t_message_record` (
  `msg_id` bigint(20) NOT NULL COMMENT '消息Id',
  `send_id` bigint(20) NOT NULL COMMENT '发送者Id',
  `receive_id` bigint(20) NOT NULL COMMENT '接受者Id',
  `type` char(1) COLLATE utf8_bin NOT NULL COMMENT '消息类型',
  `chat_type` char(1) COLLATE utf8_bin NOT NULL COMMENT '聊天类型',
  `content` varchar(500) COLLATE utf8_bin NOT NULL COMMENT '聊天内容',
  `send_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '消息发送时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`msg_id`),
  KEY `idx_msg_id` (`msg_id`),
  KEY `idx_send_id` (`send_id`),
  KEY `idx_receive_id` (`receive_id`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='消息记录表';

-- ----------------------------
-- Records of t_message_record
-- ----------------------------
INSERT INTO `t_message_record` VALUES ('903597308674052096', '775113183131074580', '786600935907659776', '1', '1', '吃了吗', '2021-10-29 15:44:46', '2021-10-29 10:53:06', '2021-10-29 15:44:46');
INSERT INTO `t_message_record` VALUES ('903597308674052097', '786600935907659776', '775113183131074580', '1', '1', '吃了', '2021-10-29 15:44:48', '2021-10-29 11:12:46', '2021-10-29 15:44:48');
INSERT INTO `t_message_record` VALUES ('903691939675901952', '775113183131074580', '786600935907659776', '2', '1', 'https://gitee.com/shizidada/moose-resource/raw/master/emoji/1/guaiwu.png', '2021-10-29 17:09:08', '2021-10-29 17:09:08', '2021-10-29 17:09:08');
INSERT INTO `t_message_record` VALUES ('903691964803977216', '775113183131074580', '786600935907659776', '2', '1', 'https://gitee.com/shizidada/moose-resource/raw/master/emoji/custom/xindong.gif', '2021-10-29 17:09:14', '2021-10-29 17:09:14', '2021-10-29 17:09:14');
INSERT INTO `t_message_record` VALUES ('903691988866699264', '775113183131074580', '786600935907659776', '2', '1', 'https://gitee.com/shizidada/moose-resource/raw/master/emoji/custom/over.jpeg', '2021-10-29 17:09:19', '2021-10-29 17:09:19', '2021-10-29 17:09:19');

DROP TABLE IF EXISTS `t_message_extra_record`;
CREATE TABLE `t_message_extra_record` (
  `extra_id` bigint(20) NOT NULL COMMENT '额外信息Id',
  `msg_id` bigint(20) NOT NULL COMMENT '消息Id',
  `attach_id` bigint(20)  NOT NULL COMMENT '附件Id',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`extra_id`),
  KEY `idx_extra_id` (`extra_id`),
  KEY `idx_msg_id` (`msg_id`),
  KEY `idx_attach_id` (`attach_id`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='消息附属额外信息表';

SET FOREIGN_KEY_CHECKS = 1;
